MerchandiseHierarchyLevel

Entity Definition

Logical Name : MerchandiseHierarchyLevel
Physical Name : CO_MRHRC_LV

Establishes the levels of the merchandise hierarchy structure for rolling up sales units and financial amounts for ITEMs.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
MerchandiseHierarchyFunctionID (FK) A unique system assigned identifier for the MerchandiseHierarchyFunction ID_MRHRC_FNC Identity integer MerchandiseHierarchyLevel(CO_MRHRC_LV)
MerchandiseHierarchyFunctionID (FK)(PK) A unique system assigned identifier for the MerchandiseHierarchyFunction ID_MRHRC_FNC Identity integer MerchandiseHierarchyFunction(CO_MRHRC_FNC)
MerchandiseHierarchyLevelID (PK) A unique system assigned identifier for the Level within the merchandise hierarchy tree. ID_MRHRC_LV Identity integer
ParentMerchandiseHierarchyLevelID (FK) Identifies a hierarchy level within a summarization tree structure for merchandise sales analysis and merchandise classification. The values for this attribute will be standardized within the ARTS Data Model. ID_MRHRC_LV_PRNT Identity integer MerchandiseHierarchyLevel(CO_MRHRC_LV)
Name The retailer-specific description associated with a merchandise-hierarchy-level-code. This attribute allows retailers to assign any description they choose to each level. DE_MRHRC_LV Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
MerchandiseHierarchyLevel has parent MerchandiseHierarchyLevel
MerchandiseHierarchyFunction defines MerchandiseHierarchyLevel
MerchandiseHierarchyLevel defines parent AssociatedMerchandiseHierarchyGroup
MerchandiseHierarchyLevel has parent MerchandiseHierarchyLevel

Logical Views containing MerchandiseHierarchyLevel

Logical View
Logical 01000 - Item Description - Macro View
Logical 01015 - Item Description - Apparel View
Logical 01040 - Item Description - Rental View
Logical 03200 - Reporting - Item Sales View
Logical 03300 - Reporting - Stock Ledger View
Logical 05100 - Taxation - Rules View
Logical 07010 - Customer Account Information Extended
Logical 07040 - Customer Segment Dependent Behavior
Logical 10200 - Enterprise - Merchandise View